TherapyPathResultsService.java

/*
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.ohdsi.webapi.service;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import javax.ws.rs.Consumes;
import javax.ws.rs.GET;
import javax.ws.rs.POST;
import javax.ws.rs.Path;
import javax.ws.rs.PathParam;
import javax.ws.rs.Produces;
import javax.ws.rs.core.MediaType;
import org.ohdsi.sql.SqlRender;
import org.ohdsi.sql.SqlTranslate;
import org.ohdsi.webapi.helper.ResourceHelper;
import org.ohdsi.webapi.source.Source;
import org.ohdsi.webapi.source.SourceDaimon;
import org.ohdsi.webapi.therapy.TherapyPathReport;
import org.ohdsi.webapi.therapy.TherapyPathVector;
import org.ohdsi.webapi.therapy.TherapySummary;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Component;

/**
 *
 * @author fdefalco
 *
 * I envision this eventually being subsumed within the cohortresults service
 *
 */
@Path("{sourceKey}/txpathresults/")
@Component
public class TherapyPathResultsService extends AbstractDaoService {

  @Path("reports")
  @GET
  @Produces(MediaType.APPLICATION_JSON)
  public List<TherapyPathReport> getReports(@PathParam("sourceKey") String sourceKey) {
    try {

      Source source = getSourceRepository().findBySourceKey(sourceKey);
      String tableQualifier = source.getTableQualifier(SourceDaimon.DaimonType.Results);

      String sql_statement = ResourceHelper.GetResourceAsString("/resources/therapypathresults/sql/getTherapyPathReports.sql");
      sql_statement = SqlRender.renderSql(sql_statement, new String[]{"OHDSI_schema"}, new String[]{tableQualifier});
      sql_statement = SqlTranslate.translateSql(sql_statement, "sql server", source.getSourceDialect());
      return getSourceJdbcTemplate(source).query(sql_statement, new RowMapper<TherapyPathReport>() {
        @Override
        public TherapyPathReport mapRow(final ResultSet rs, final int arg1) throws SQLException {
          final TherapyPathReport report = new TherapyPathReport();
          report.reportId = rs.getInt(1);
          report.reportCaption = rs.getString(2);
          report.year = Integer.toString(rs.getInt(3));

          if (report.year.equals("9999")) {
            report.year = "All Years";
          }

          report.disease = rs.getString(4);
          report.datasource = rs.getString(5);
          return report;
        }
      });
    } catch (Exception exception) {
      throw new RuntimeException("Error getting therapy path reports" + exception.getMessage());
    }
  }

  @Path("report/{id}")
  @GET
  @Produces(MediaType.APPLICATION_JSON)
  public List<TherapyPathVector> getTherapyPathVectors(@PathParam("id") String id, @PathParam("sourceKey") String sourceKey) {
    try {
      
      Source source = getSourceRepository().findBySourceKey(sourceKey);
      String tableQualifier = source.getTableQualifier(SourceDaimon.DaimonType.Results);
      
      String sql_statement = ResourceHelper.GetResourceAsString("/resources/therapypathresults/sql/getTherapyPathVectors.sql");
      sql_statement = SqlRender.renderSql(sql_statement, new String[]{"id"}, new String[]{id});
      sql_statement = SqlTranslate.translateSql(sql_statement, "sql server", source.getSourceDialect());
      return getSourceJdbcTemplate(source).query(sql_statement, new RowMapper<TherapyPathVector>() {
        @Override
        public TherapyPathVector mapRow(final ResultSet rs, final int arg1) throws SQLException {
          final TherapyPathVector vector = new TherapyPathVector();
          vector.key = rs.getString("ResultKey");
          vector.count = rs.getInt("ResultCount");
          return vector;
        }
      });
    } catch (Exception exception) {
      throw new RuntimeException("Error getting therapy path vectors - " + exception.getMessage());
    }
  }

  @Path("summary")
  @POST
  @Produces(MediaType.APPLICATION_JSON)
  @Consumes(MediaType.APPLICATION_JSON)
  public List<TherapySummary> getSummaries(@PathParam("sourceKey") String sourceKey, String[] identifiers) {
    try {
      String sql_statement = ResourceHelper.GetResourceAsString("/resources/therapypathresults/sql/getTherapySummaries.sql");

      Source source = getSourceRepository().findBySourceKey(sourceKey);
      String tableQualifier = source.getTableQualifier(SourceDaimon.DaimonType.Results);      
      
      String identifiersList = "";
      for (String identifier : identifiers) {
        if (identifiersList.length() > 0) {
          identifiersList += ", ";
        }

        identifiersList += identifier;
      }

      sql_statement = SqlRender.renderSql(sql_statement, new String[]{"identifiersList"}, new String[]{identifiersList});
      sql_statement = SqlTranslate.translateSql(sql_statement, "sql server", source.getSourceDialect());
      return getSourceJdbcTemplate(source).query(sql_statement, new RowMapper<TherapySummary>() {
        @Override
        public TherapySummary mapRow(final ResultSet rs, final int arg1) throws SQLException {
          final TherapySummary summary = new TherapySummary();
          summary.key = rs.getString(1);
          summary.name = rs.getString(2);
          summary.tx1 = rs.getInt(3);
          summary.tx2 = rs.getInt(4);
          summary.tx3 = rs.getInt(5);
          summary.total = rs.getInt(6);
          return summary;
        }
      });
    } catch (Exception exception) {
      throw new RuntimeException("Error getting therapy path summary - " + exception.getMessage());
    }
  }
}